Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	30697
Missing cells	55284
Missing cells (%)	9.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.7 MiB
Average record size in memory	535.2 B

Variable types

Numeric	11
Boolean	1
Categorical	7

Alerts

`home_away` has a high cardinality: 74 distinct values	High cardinality
`type_of_shot` has a high cardinality: 57 distinct values	High cardinality
`location_y` is highly correlated with `distance_of_shot` and 1 other fields	High correlation
`remaining_min` is highly correlated with `remaining_min_1`	High correlation
`power_of_shot` is highly correlated with `power_of_shot_1`	High correlation
`remaining_sec` is highly correlated with `remaining_sec_1`	High correlation
`distance_of_shot` is highly correlated with `location_y` and 1 other fields	High correlation
`remaining_min_1` is highly correlated with `remaining_min`	High correlation
`power_of_shot_1` is highly correlated with `power_of_shot`	High correlation
`remaining_sec_1` is highly correlated with `remaining_sec`	High correlation
`distance_of_shot_1` is highly correlated with `location_y` and 1 other fields	High correlation
`location_y` is highly correlated with `distance_of_shot`	High correlation
`distance_of_shot` is highly correlated with `location_y`	High correlation
`location_y` is highly correlated with `distance_of_shot`	High correlation
`remaining_min` is highly correlated with `remaining_min_1`	High correlation
`power_of_shot` is highly correlated with `power_of_shot_1`	High correlation
`remaining_sec` is highly correlated with `remaining_sec_1`	High correlation
`distance_of_shot` is highly correlated with `location_y` and 1 other fields	High correlation
`remaining_min_1` is highly correlated with `remaining_min`	High correlation
`power_of_shot_1` is highly correlated with `power_of_shot`	High correlation
`remaining_sec_1` is highly correlated with `remaining_sec`	High correlation
`distance_of_shot_1` is highly correlated with `distance_of_shot`	High correlation
`location_x` is highly correlated with `distance_of_shot` and 6 other fields	High correlation
`location_y` is highly correlated with `distance_of_shot` and 5 other fields	High correlation
`remaining_sec` is highly correlated with `remaining_sec_1`	High correlation
`distance_of_shot` is highly correlated with `location_x` and 7 other fields	High correlation
`area_of_shot` is highly correlated with `location_x` and 7 other fields	High correlation
`shot_basics` is highly correlated with `location_x` and 7 other fields	High correlation
`range_of_shot` is highly correlated with `location_x` and 7 other fields	High correlation
`home_away` is highly correlated with `lat_lng`	High correlation
`lat_lng` is highly correlated with `home_away`	High correlation
`type_of_shot` is highly correlated with `location_x` and 5 other fields	High correlation
`type_of_combined_shot` is highly correlated with `location_x` and 6 other fields	High correlation
`remaining_sec_1` is highly correlated with `remaining_sec`	High correlation
`distance_of_shot_1` is highly correlated with `location_x` and 7 other fields	High correlation
`location_x` has 1461 (4.8%) missing values	Missing
`location_y` has 1540 (5.0%) missing values	Missing
`remaining_min` has 1562 (5.1%) missing values	Missing
`power_of_shot` has 1486 (4.8%) missing values	Missing
`remaining_sec` has 1594 (5.2%) missing values	Missing
`distance_of_shot` has 1567 (5.1%) missing values	Missing
`area_of_shot` has 1502 (4.9%) missing values	Missing
`shot_basics` has 1575 (5.1%) missing values	Missing
`range_of_shot` has 1564 (5.1%) missing values	Missing
`home_away` has 1497 (4.9%) missing values	Missing
`lat_lng` has 1565 (5.1%) missing values	Missing
`type_of_shot` has 15280 (49.8%) missing values	Missing
`type_of_combined_shot` has 15417 (50.2%) missing values	Missing
`remaining_min_1` has 1535 (5.0%) missing values	Missing
`power_of_shot_1` has 1539 (5.0%) missing values	Missing
`knockout_match_1` has 1493 (4.9%) missing values	Missing
`remaining_sec_1` has 1539 (5.0%) missing values	Missing
`distance_of_shot_1` has 1568 (5.1%) missing values	Missing
`location_x` has 5195 (16.9%) zeros	Zeros
`location_y` has 5324 (17.3%) zeros	Zeros
`remaining_min` has 3681 (12.0%) zeros	Zeros
`remaining_sec` has 931 (3.0%) zeros	Zeros
`remaining_min_1` has 2921 (9.5%) zeros	Zeros
`knockout_match_1` has 19831 (64.6%) zeros	Zeros
`remaining_sec_1` has 747 (2.4%) zeros	Zeros

Reproduction

Analysis started	2022-02-08 10:22:55.877425
Analysis finished	2022-02-08 10:23:18.093121
Duration	22.22 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

location_x
Real number (ℝ)

HIGH CORRELATION
MISSING
ZEROS

Distinct	488
Distinct (%)	1.7%
Missing	1461
Missing (%)	4.8%
Infinite	0
Infinite (%)	0.0%
Mean	7.383876043

Minimum	-250
Maximum	248
Zeros	5195
Zeros (%)	16.9%
Negative	10981
Negative (%)	35.8%
Memory size	479.6 KiB

Quantile statistics

Minimum	-250
5-th percentile	-177
Q1	-68
median	0
Q3	95
95-th percentile	182
Maximum	248
Range	498
Interquartile range (IQR)	163

Descriptive statistics

Standard deviation	110.2630492
Coefficient of variation (CV)	14.93294966
Kurtosis	-0.6831823168
Mean	7.383876043
Median Absolute Deviation (MAD)	85
Skewness	-0.08754995724
Sum	215875
Variance	12157.94003
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5195	16.9%
1	256	0.8%
138	143	0.5%
159	142	0.5%
-2	139	0.5%
136	137	0.4%
144	136	0.4%
108	135	0.4%
6	130	0.4%
-8	130	0.4%
Other values (478)	22693	73.9%
(Missing)	1461	4.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-250	1	< 0.1%
-248	1	< 0.1%
-246	3	< 0.1%
-245	2	< 0.1%
-244	2	< 0.1%
-243	4	< 0.1%
-242	5	< 0.1%
-241	10	< 0.1%
-240	12	< 0.1%
-239	5	< 0.1%

Value	Count	Frequency (%)
248	5	< 0.1%
246	2	< 0.1%
245	2	< 0.1%
244	3	< 0.1%
242	7	< 0.1%
241	8	< 0.1%
240	7	< 0.1%
239	6	< 0.1%
238	12	< 0.1%
237	18	0.1%

location_y
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	450
Distinct (%)	1.5%
Missing	1540
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	91.1269335

Minimum	-44
Maximum	791
Zeros	5324
Zeros (%)	17.3%
Negative	1447
Negative (%)	4.7%
Memory size	479.6 KiB

Quantile statistics

Minimum	-44
5-th percentile	0
Q1	4
median	74
Q3	160
95-th percentile	241
Maximum	791
Range	835
Interquartile range (IQR)	156

Descriptive statistics

Standard deviation	87.67639516
Coefficient of variation (CV)	0.9621348134
Kurtosis	1.166423204
Mean	91.1269335
Median Absolute Deviation (MAD)	74
Skewness	0.8040843553
Sum	2656988
Variance	7687.150268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5324	17.3%
7	239	0.8%
12	215	0.7%
3	207	0.7%
15	196	0.6%
17	196	0.6%
156	194	0.6%
26	182	0.6%
23	181	0.6%
61	177	0.6%
Other values (440)	22046	71.8%
(Missing)	1540	5.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-44	2	< 0.1%
-43	1	< 0.1%
-42	2	< 0.1%
-40	2	< 0.1%
-39	2	< 0.1%
-38	2	< 0.1%
-37	3	< 0.1%
-36	5	< 0.1%
-35	5	< 0.1%
-34	3	< 0.1%

Value	Count	Frequency (%)
791	1	< 0.1%
773	1	< 0.1%
741	2	< 0.1%
728	1	< 0.1%
711	1	< 0.1%
702	1	< 0.1%
697	1	< 0.1%
696	1	< 0.1%
679	1	< 0.1%
664	1	< 0.1%

remaining_min
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	1562
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.883233225

Minimum	0
Maximum	11
Zeros	3681
Zeros (%)	12.0%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.452532713
Coefficient of variation (CV)	0.7070177798
Kurtosis	-1.164098439
Mean	4.883233225
Median Absolute Deviation (MAD)	3
Skewness	0.1998925127
Sum	142273
Variance	11.91998213
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	3681	12.0%
4	2709	8.8%
3	2698	8.8%
2	2688	8.8%
1	2600	8.5%
5	2508	8.2%
6	2256	7.3%
7	2094	6.8%
9	2089	6.8%
8	2028	6.6%
Other values (2)	3784	12.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3681	12.0%
1	2600	8.5%
2	2688	8.8%
3	2698	8.8%
4	2709	8.8%
5	2508	8.2%
6	2256	7.3%
7	2094	6.8%
8	2028	6.6%
9	2089	6.8%

Value	Count	Frequency (%)
11	1768	5.8%
10	2016	6.6%
9	2089	6.8%
8	2028	6.6%
7	2094	6.8%
6	2256	7.3%
5	2508	8.2%
4	2709	8.8%
3	2698	8.8%
2	2688	8.8%

power_of_shot
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	1486
Missing (%)	4.8%
Infinite	0
Infinite (%)	0.0%
Mean	2.519359146

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	3
95-th percentile	4
Maximum	7
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.153975941
Coefficient of variation (CV)	0.4580434445
Kurtosis	-1.164876715
Mean	2.519359146
Median Absolute Deviation (MAD)	1
Skewness	0.05634692367
Sum	73593
Variance	1.331660473
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	7885	25.7%
1	7659	25.0%
4	6910	22.5%
2	6399	20.8%
5	314	1.0%
6	37	0.1%
7	7	< 0.1%
(Missing)	1486	4.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	7659	25.0%
2	6399	20.8%
3	7885	25.7%
4	6910	22.5%
5	314	1.0%
6	37	0.1%
7	7	< 0.1%

Value	Count	Frequency (%)
7	7	< 0.1%
6	37	0.1%
5	314	1.0%
4	6910	22.5%
3	7885	25.7%
2	6399	20.8%
1	7659	25.0%

remaining_sec
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	60
Distinct (%)	0.2%
Missing	1594
Missing (%)	5.2%
Infinite	0
Infinite (%)	0.0%
Mean	28.32938185

Minimum	0
Maximum	59
Zeros	931
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	13
median	28
Q3	43
95-th percentile	56
Maximum	59
Range	59
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	17.47066279
Coefficient of variation (CV)	0.6166976351
Kurtosis	-1.183681156
Mean	28.32938185
Median Absolute Deviation (MAD)	15
Skewness	0.03444775101
Sum	824470
Variance	305.2240583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	931	3.0%
1	620	2.0%
2	572	1.9%
28	531	1.7%
4	530	1.7%
32	525	1.7%
5	523	1.7%
36	522	1.7%
25	520	1.7%
41	516	1.7%
Other values (50)	23313	75.9%
(Missing)	1594	5.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	931	3.0%
1	620	2.0%
2	572	1.9%
3	494	1.6%
4	530	1.7%
5	523	1.7%
6	456	1.5%
7	465	1.5%
8	494	1.6%
9	445	1.4%

Value	Count	Frequency (%)
59	440	1.4%
58	422	1.4%
57	477	1.6%
56	436	1.4%
55	407	1.3%
54	424	1.4%
53	412	1.3%
52	443	1.4%
51	423	1.4%
50	450	1.5%

distance_of_shot
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	73
Distinct (%)	0.3%
Missing	1567
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	33.44888431

Minimum	20
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	20
5-th percentile	20
Q1	25
median	35
Q3	41
95-th percentile	46
Maximum	99
Range	79
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.369656489
Coefficient of variation (CV)	0.2801186551
Kurtosis	0.02825934777
Mean	33.44888431
Median Absolute Deviation (MAD)	8
Skewness	0.09989205623
Sum	974366
Variance	87.79046273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	5258	17.1%
45	1856	6.0%
44	1433	4.7%
37	1415	4.6%
38	1341	4.4%
36	1339	4.4%
39	1299	4.2%
46	1213	4.0%
40	1144	3.7%
35	1103	3.6%
Other values (63)	11729	38.2%
(Missing)	1567	5.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	5258	17.1%
21	597	1.9%
22	541	1.8%
23	361	1.2%
24	350	1.1%
25	508	1.7%
26	611	2.0%
27	672	2.2%
28	640	2.1%
29	581	1.9%

Value	Count	Frequency (%)
99	1	< 0.1%
97	1	< 0.1%
94	3	< 0.1%
91	1	< 0.1%
90	2	< 0.1%
89	1	< 0.1%
88	2	< 0.1%
87	2	< 0.1%
85	1	< 0.1%
84	2	< 0.1%

is_goal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	269.8 KiB

True	17147
False	13550

Common Values
Chart

Value	Count	Frequency (%)
True	17147	55.9%
False	13550	44.1%

area_of_shot
Categorical

HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	1502
Missing (%)	4.9%
Memory size	2.2 MiB

Center(C)	12761
Right Side Center(RC)	4562
Right Side(R)	4370
Left Side Center(LC)	3848
Left Side(L)	3573

Length

Max length	21
Median length	12
Mean length	13.30470971
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Right Side(R)
2nd row	Left Side(L)
3rd row	Left Side Center(LC)
4th row	Right Side Center(RC)
5th row	Center(C)

Common Values

Value	Count	Frequency (%)
Center(C)	12761	41.6%
Right Side Center(RC)	4562	14.9%
Right Side(R)	4370	14.2%
Left Side Center(LC)	3848	12.5%
Left Side(L)	3573	11.6%
Mid Ground(MG)	81	0.3%
(Missing)	1502	4.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
center(c	12761	23.6%
right	8932	16.5%
side	8410	15.6%
left	7421	13.7%
center(rc	4562	8.4%
side(r	4370	8.1%
center(lc	3848	7.1%
side(l	3573	6.6%
mid	81	0.1%
ground(mg	81	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

shot_basics
Categorical

HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	1575
Missing (%)	5.1%
Memory size	2.1 MiB

Mid Range	11955
Goal Area	6787
Penalty Spot	5321
Goal Line	4357
Right Corner	367
Other values (2)	335

Length

Max length	15
Median length	9
Mean length	9.618158094
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mid Range
2nd row	Mid Range
3rd row	Mid Range
4th row	Mid Range
5th row	Goal Area

Common Values

Value	Count	Frequency (%)
Mid Range	11955	38.9%
Goal Area	6787	22.1%
Penalty Spot	5321	17.3%
Goal Line	4357	14.2%
Right Corner	367	1.2%
Left Corner	268	0.9%
Mid Ground Line	67	0.2%
(Missing)	1575	5.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
mid	12022	20.6%
range	11955	20.5%
goal	11144	19.1%
area	6787	11.6%
penalty	5321	9.1%
spot	5321	9.1%
line	4424	7.6%
corner	635	1.1%
right	367	0.6%
left	268	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

range_of_shot
Categorical

HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	1564
Missing (%)	5.1%
Memory size	2.1 MiB

Less Than 8 ft.	8933
16-24 ft.	7892
8-16 ft.	6290
24+ ft.	5937
Back Court Shot	81

Length

Max length	15
Median length	9
Mean length	10.23296605
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	16-24 ft.
2nd row	8-16 ft.
3rd row	16-24 ft.
4th row	16-24 ft.
5th row	Less Than 8 ft.

Common Values

Value	Count	Frequency (%)
Less Than 8 ft.	8933	29.1%
16-24 ft.	7892	25.7%
8-16 ft.	6290	20.5%
24+ ft.	5937	19.3%
Back Court Shot	81	0.3%
(Missing)	1564	5.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ft	29052	38.1%
less	8933	11.7%
than	8933	11.7%
8	8933	11.7%
16-24	7892	10.4%
8-16	6290	8.3%
24	5937	7.8%
back	81	0.1%
court	81	0.1%
shot	81	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

home_away
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	74
Distinct (%)	0.3%
Missing	1497
Missing (%)	4.9%
Memory size	2.2 MiB

MANU @ SAS	971
MANU vs. SAS	890
MANU @ SAC	845
MANU @ DEN	832
MANU vs. HOU	828
Other values (69)	24834

Length

Max length	12
Median length	10
Mean length	10.97335616
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MANU @ POR
2nd row	MANU @ POR
3rd row	MANU @ POR
4th row	MANU @ POR
5th row	MANU @ POR

Common Values

Value	Count	Frequency (%)
MANU @ SAS	971	3.2%
MANU vs. SAS	890	2.9%
MANU @ SAC	845	2.8%
MANU @ DEN	832	2.7%
MANU vs. HOU	828	2.7%
MANU @ PHX	825	2.7%
MANU vs. PHX	805	2.6%
MANU @ HOU	756	2.5%
MANU @ POR	755	2.5%
MANU vs. DEN	729	2.4%
Other values (64)	20964	68.3%
(Missing)	1497	4.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
manu	29200	33.3%
	14989	17.1%
vs	14211	16.2%
sas	1861	2.1%
phx	1630	1.9%
hou	1584	1.8%
sac	1563	1.8%
den	1561	1.8%
por	1473	1.7%
min	1403	1.6%
Other values (31)	18125	20.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

lat_lng
Categorical

HIGH CORRELATION
MISSING

Distinct	38
Distinct (%)	0.1%
Missing	1565
Missing (%)	5.1%
Memory size	2.5 MiB

42.982923, -71.446094	14171
29.444994, -98.524120	975
38.567296, -121.456638	843
39.739968, -104.954013	826
33.552026, -112.071667	817
Other values (33)	11500

Length

Max length	22
Median length	21
Mean length	21.19802966
Min length	21

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	45.539131, -122.651648
2nd row	45.539131, -122.651648
3rd row	45.539131, -122.651648
4th row	45.539131, -122.651648
5th row	45.539131, -122.651648

Common Values

Value	Count	Frequency (%)
42.982923, -71.446094	14171	46.2%
29.444994, -98.524120	975	3.2%
38.567296, -121.456638	843	2.7%
39.739968, -104.954013	826	2.7%
33.552026, -112.071667	817	2.7%
45.539131, -122.651648	744	2.4%
29.740325, -95.365762	741	2.4%
46.667324, -94.419250	706	2.3%
40.774891, -111.930790	702	2.3%
37.754130, -122.437947	654	2.1%
Other values (28)	7953	25.9%
(Missing)	1565	5.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
42.982923	14171	24.3%
71.446094	14171	24.3%
29.444994	975	1.7%
98.524120	975	1.7%
38.567296	843	1.4%
121.456638	843	1.4%
39.739968	826	1.4%
104.954013	826	1.4%
33.552026	817	1.4%
112.071667	817	1.4%
Other values (66)	23000	39.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

type_of_shot
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	57
Distinct (%)	0.4%
Missing	15280
Missing (%)	49.8%
Memory size	1.7 MiB

shot - 39	1445
shot - 36	1292
shot - 4	1129
shot - 15	701
shot - 38	676
Other values (52)	10174

Length

Max length	9
Median length	9
Mean length	8.83440358
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	shot - 30
2nd row	shot - 45
3rd row	shot - 25
4th row	shot - 17
5th row	shot - 36

Common Values

Value	Count	Frequency (%)
shot - 39	1445	4.7%
shot - 36	1292	4.2%
shot - 4	1129	3.7%
shot - 15	701	2.3%
shot - 38	676	2.2%
shot - 44	609	2.0%
shot - 43	400	1.3%
shot - 17	382	1.2%
shot - 12	361	1.2%
shot - 52	338	1.1%
Other values (47)	8084	26.3%
(Missing)	15280	49.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
shot	15417	33.3%
	15417	33.3%
39	1445	3.1%
36	1292	2.8%
4	1129	2.4%
15	701	1.5%
38	676	1.5%
44	609	1.3%
43	400	0.9%
17	382	0.8%
Other values (49)	8783	19.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

type_of_combined_shot
Categorical

HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	15417
Missing (%)	50.2%
Memory size	1.7 MiB

shot - 3	11685
shot - 4	2736
shot - 1	609
shot - 5	90
shot - 2	82

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	shot - 3
2nd row	shot - 1
3rd row	shot - 4
4th row	shot - 3
5th row	shot - 3

Common Values

Value	Count	Frequency (%)
shot - 3	11685	38.1%
shot - 4	2736	8.9%
shot - 1	609	2.0%
shot - 5	90	0.3%
shot - 2	82	0.3%
shot - 0	78	0.3%
(Missing)	15417	50.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
shot	15280	33.3%
	15280	33.3%
3	11685	25.5%
4	2736	6.0%
1	609	1.3%
5	90	0.2%
2	82	0.2%
0	78	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

remaining_min_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	291
Distinct (%)	1.0%
Missing	1535
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.20461483

Minimum	0
Maximum	128.7616
Zeros	2921
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	6
Q3	11
95-th percentile	95.64
Maximum	128.7616
Range	128.7616
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	29.41697273
Coefficient of variation (CV)	1.61590745
Kurtosis	2.959896061
Mean	18.20461483
Median Absolute Deviation (MAD)	4
Skewness	2.051408675
Sum	530882.9776
Variance	865.3582846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2921	9.5%
4	2179	7.1%
3	2154	7.0%
2	2134	7.0%
1	2061	6.7%
5	1976	6.4%
6	1758	5.7%
9	1650	5.4%
7	1646	5.4%
8	1639	5.3%
Other values (281)	9044	29.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2921	9.5%
1	2061	6.7%
2	2134	7.0%
3	2154	7.0%
4	2179	7.1%
5	1976	6.4%
6	1758	5.7%
7	1646	5.4%
8	1639	5.3%
9	1650	5.4%

Value	Count	Frequency (%)
128.7616	4	< 0.1%
127.7616	1	< 0.1%
126.7616	2	< 0.1%
124.7616	4	< 0.1%
120.7616	1	< 0.1%
119.7616	3	< 0.1%
119.64	50	0.2%
118.7616	3	< 0.1%
118.64	49	0.2%
117.7616	3	< 0.1%

power_of_shot_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	206
Distinct (%)	0.7%
Missing	1539
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.99410934

Minimum	1
Maximum	118.36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	94.36
Maximum	118.36
Range	117.36
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	29.67681505
Coefficient of variation (CV)	1.855484068
Kurtosis	3.006135407
Mean	15.99410934
Median Absolute Deviation (MAD)	1
Skewness	2.085485068
Sum	466356.24
Variance	880.7133514
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	6268	20.4%
1	6085	19.8%
4	5485	17.9%
2	5093	16.6%
5	263	0.9%
95.36	75	0.2%
83.36	71	0.2%
80.36	69	0.2%
30.36	68	0.2%
72.36	68	0.2%
Other values (196)	5613	18.3%
(Missing)	1539	5.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6085	19.8%
2	5093	16.6%
3	6268	20.4%
4	5485	17.9%
5	263	0.9%
6	31	0.1%
7	6	< 0.1%
13.6	6	< 0.1%
14.6	5	< 0.1%
15.6	1	< 0.1%

Value	Count	Frequency (%)
118.36	50	0.2%
117.36	60	0.2%
116.36	59	0.2%
115.36	56	0.2%
114.36	60	0.2%
113.36	58	0.2%
112.6	3	< 0.1%
112.36	66	0.2%
111.6	4	< 0.1%
111.36	49	0.2%

knockout_match_1
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	382
Distinct (%)	1.3%
Missing	1493
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%
Mean	16.59940165

Minimum	0
Maximum	141.35232
Zeros	19831
Zeros (%)	64.6%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	105.8
Maximum	141.35232
Range	141.35232
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	35.17201575
Coefficient of variation (CV)	2.118872505
Kurtosis	2.474602919
Mean	16.59940165
Median Absolute Deviation (MAD)	0
Skewness	1.966943168
Sum	484768.9258
Variance	1237.070692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19831	64.6%
1	3382	11.0%
87.608	38	0.1%
132.608	33	0.1%
38.608	31	0.1%
93.608	30	0.1%
129.608	30	0.1%
95.608	30	0.1%
40.608	30	0.1%
47.8	29	0.1%
Other values (372)	5740	18.7%
(Missing)	1493	4.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	19831	64.6%
1	3382	11.0%
17.8	16	0.1%
18.8	15	< 0.1%
19.8	24	0.1%
20.8	15	< 0.1%
21.8	13	< 0.1%
22.8	18	0.1%
23.8	21	0.1%
24.8	12	< 0.1%

Value	Count	Frequency (%)
141.35232	4	< 0.1%
140.35232	3	< 0.1%
139.35232	1	< 0.1%
137.608	27	0.1%
137.35232	6	< 0.1%
136.608	22	0.1%
136.35232	1	< 0.1%
135.608	20	0.1%
135.35232	3	< 0.1%
134.608	21	0.1%

remaining_sec_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	354
Distinct (%)	1.2%
Missing	1539
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.02730256

Minimum	0
Maximum	144.7856
Zeros	747
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	17
median	35
Q3	52
95-th percentile	106.2
Maximum	144.7856
Range	144.7856
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	29.83528353
Coefficient of variation (CV)	0.7644720895
Kurtosis	1.399632538
Mean	39.02730256
Median Absolute Deviation (MAD)	17
Skewness	1.190248182
Sum	1137958.088
Variance	890.1441435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	747	2.4%
1	509	1.7%
28	445	1.4%
2	442	1.4%
4	434	1.4%
41	423	1.4%
5	410	1.3%
36	410	1.3%
44	409	1.3%
24	407	1.3%
Other values (344)	24522	79.9%
(Missing)	1539	5.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	747	2.4%
1	509	1.7%
2	442	1.4%
3	398	1.3%
4	434	1.4%
5	410	1.3%
6	368	1.2%
7	372	1.2%
8	383	1.2%
9	350	1.1%

Value	Count	Frequency (%)
144.7856	26	0.1%
143.7856	17	0.1%
143.7216	1	< 0.1%
142.7856	17	0.1%
142.7216	7	< 0.1%
141.7856	25	0.1%
141.7216	3	< 0.1%
140.7856	29	0.1%
140.7216	1	< 0.1%
139.7856	31	0.1%

distance_of_shot_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	271
Distinct (%)	0.9%
Missing	1568
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	38.8018519

Minimum	9.4
Maximum	115.728
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	479.6 KiB

Quantile statistics

Minimum	9.4
5-th percentile	20
Q1	26
median	36
Q3	44
95-th percentile	85.4
Maximum	115.728
Range	106.328
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	18.78771057
Coefficient of variation (CV)	0.4841962341
Kurtosis	3.317907443
Mean	38.8018519
Median Absolute Deviation (MAD)	9
Skewness	1.734477383
Sum	1130259.144
Variance	352.9780683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	4232	13.8%
45	1511	4.9%
44	1162	3.8%
37	1125	3.7%
38	1086	3.5%
36	1036	3.4%
39	1019	3.3%
46	965	3.1%
40	931	3.0%
35	884	2.9%
Other values (261)	15178	49.4%
(Missing)	1568	5.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.4	53	0.2%
10.4	42	0.1%
11.4	42	0.1%
12.4	44	0.1%
13.4	43	0.1%
14.4	47	0.2%
15.4	48	0.2%
16.4	64	0.2%
16.728	13	< 0.1%
17.4	52	0.2%

Value	Count	Frequency (%)
115.728	11	< 0.1%
114.728	10	< 0.1%
113.728	8	< 0.1%
112.728	10	< 0.1%
111.728	9	< 0.1%
110.728	10	< 0.1%
109.728	11	< 0.1%
108.728	6	< 0.1%
108.4	60	0.2%
107.728	12	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	location_x	location_y	remaining_min	power_of_shot	remaining_sec	distance_of_shot	is_goal	area_of_shot	shot_basics	range_of_shot	home_away	lat_lng	type_of_shot	type_of_combined_shot	remaining_min_1	power_of_shot_1	knockout_match_1	remaining_sec_1	distance_of_shot_1
0	167.0	72.0	10.0	1.0	27.0	38.0	True	Right Side(R)	Mid Range	16-24 ft.	MANU @ POR	45.539131, -122.651648	shot - 30	NaN	10.00	1.0	50.608	54.2000	38.0
1	-157.0	0.0	10.0	1.0	22.0	35.0	False	Left Side(L)	Mid Range	8-16 ft.	MANU @ POR	45.539131, -122.651648	shot - 45	NaN	10.00	1.0	28.800	22.0000	35.0
2	-101.0	135.0	7.0	1.0	45.0	36.0	True	Left Side Center(LC)	Mid Range	16-24 ft.	NaN	45.539131, -122.651648	shot - 25	NaN	92.64	1.0	0.000	63.7216	54.4
3	138.0	175.0	6.0	1.0	52.0	42.0	False	Right Side Center(RC)	Mid Range	16-24 ft.	MANU @ POR	45.539131, -122.651648	NaN	shot - 3	NaN	1.0	122.608	52.0000	42.0
4	0.0	0.0	NaN	2.0	19.0	20.0	True	Center(C)	Goal Area	Less Than 8 ft.	MANU @ POR	45.539131, -122.651648	NaN	shot - 1	42.64	2.0	0.000	19.0000	20.0
5	-145.0	-11.0	9.0	3.0	32.0	34.0	False	Left Side(L)	Mid Range	8-16 ft.	MANU @ POR	45.539131, -122.651648	shot - 17	NaN	9.00	3.0	0.000	NaN	34.0
6	0.0	0.0	8.0	NaN	52.0	20.0	True	Center(C)	Goal Area	Less Than 8 ft.	MANU @ POR	45.539131, -122.651648	NaN	shot - 4	8.00	3.0	0.000	112.2000	89.4
7	1.0	28.0	8.0	3.0	5.0	22.0	True	Center(C)	Goal Area	Less Than 8 ft.	MANU @ POR	45.539131, -122.651648	NaN	shot - 3	68.64	3.0	0.000	5.0000	22.0
8	-65.0	NaN	6.0	3.0	12.0	32.0	True	Left Side(L)	Goal Line	8-16 ft.	MANU @ POR	45.539131, -122.651648	shot - 36	NaN	6.00	3.0	0.000	12.0000	32.0
9	-33.0	NaN	3.0	3.0	36.0	32.0	False	Center(C)	Goal Line	8-16 ft.	MANU @ POR	45.539131, -122.651648	shot - 44	NaN	3.00	3.0	0.000	52.2000	NaN

Last rows

	location_x	location_y	remaining_min	power_of_shot	remaining_sec	distance_of_shot	is_goal	area_of_shot	shot_basics	range_of_shot	home_away	lat_lng	type_of_shot	type_of_combined_shot	remaining_min_1	power_of_shot_1	knockout_match_1	remaining_sec_1	distance_of_shot_1
30687	40.0	100.0	3.0	3.0	18.0	30.0	True	Center(C)	Goal Line	8-16 ft.	NaN	42.982923, -71.446094	shot - 54	NaN	3.00	3.00	1.0	18.0000	30.000
30688	-126.0	61.0	1.0	3.0	7.0	33.0	True	Left Side(L)	Mid Range	8-16 ft.	MANU vs. IND	42.982923, -71.446094	NaN	shot - 3	37.64	NaN	1.0	7.0000	16.400
30689	-12.0	679.0	0.0	3.0	0.0	87.0	False	Mid Ground(MG)	Mid Ground Line	Back Court Shot	MANU vs. IND	42.982923, -71.446094	NaN	shot - 3	NaN	31.60	1.0	0.0000	45.728
30690	-113.0	100.0	11.0	4.0	37.0	35.0	False	Left Side(L)	Mid Range	8-16 ft.	MANU vs. IND	42.982923, -71.446094	NaN	shot - 3	11.00	23.36	1.0	37.0000	35.000
30691	0.0	0.0	NaN	4.0	4.0	20.0	False	Center(C)	Goal Area	Less Than 8 ft.	MANU vs. IND	42.982923, -71.446094	shot - 4	NaN	7.00	4.00	27.8	59.7856	20.000
30692	1.0	48.0	6.0	4.0	5.0	24.0	False	Center(C)	NaN	Less Than 8 ft.	MANU vs. IND	42.982923, -71.446094	shot - 1	NaN	17.20	4.00	1.0	5.0000	24.000
30693	0.0	0.0	6.0	4.0	5.0	20.0	True	Center(C)	Goal Area	Less Than 8 ft.	MANU vs. IND	42.982923, -71.446094	shot - 49	NaN	6.00	64.36	1.0	5.0000	20.000
30694	-134.0	166.0	3.0	4.0	28.0	41.0	True	Left Side Center(LC)	Mid Range	16-24 ft.	MANU vs. IND	NaN	NaN	shot - 3	3.00	4.00	1.0	28.0000	41.000
30695	31.0	267.0	2.0	4.0	10.0	46.0	False	Center(C)	Penalty Spot	NaN	MANU vs. IND	42.982923, -71.446094	shot - 26	NaN	2.00	112.36	1.0	10.0000	46.000
30696	1.0	NaN	0.0	4.0	39.0	27.0	False	Center(C)	Goal Line	Less Than 8 ft.	MANU vs. IND	42.982923, -71.446094	shot - 45	NaN	0.00	4.00	1.0	39.0000	27.000

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows